lookup transformation with screenshots
No Answer is Posted For this Question
Be the First to Post Answer
What are the types of maping wizards that r to be provided in Informatica?
how can we use sorter transformation in joins?
Mapplets can you use an active transformation in a mapplet,
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
Explain the types of transformations?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
without using emailtask how will send a mail from informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
How to eliminate 1st and last rows from the source and load the inbetween rows.