Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?




475
views
asked marvit September 20, 2014 08:01 AM  

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?


           

2 Answers



 
answered By   0  

We can write source query in informatica wrapper script and store the query in variable and then pass the query variable in source qualifier query in mapping. So we can easily add new column or change query in wrapper script without changing mapping and we no need to refresh mapping also.

Wrapper Script SQLQUERY="SELECT EMPID,EMPNAME,EMPCITY FROM EMPLOYEE"

Source Qualifier $$SQL_QUERY -> Just pass this variable SQ in mapping.

flag   
   add comment

 
answered By vishnoiprem   0  
There is no set way to achieve this , you have to come up with some general mapping depending on your scenario like you can read the whole row as a single column and then segregate cols based on the delimiter using a set of instring and substr functions or any othe workaround that suits the scenario. The bottomline is that the solution will depend a lot on the assumptions and data you have.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert