how we load the data from source to staging area
Answers were Sorted based on User's Feedback
Answer / manik
By using one to one mapping we can load data into staging area like how we will load Flat file data into staging relational table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
How can we get multiple output values using an unconnected lookup transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the difference between Bitmap and Btree index?
If we have lookup table in workflow how do you trouble shhot to increase performance?
Limitation of REPLACESTR. Is there any character limitation to it.
can anyone explain me about sales project in informatica?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
Target is zero file and how can you send the email?
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression