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 |
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Differentiate between Load Manager and DTM?
What do you understand by a term domain?
Why sorter is an active transformation?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
can you please explain me pre session and post session options?
Define filter transformation?
what is casual dimension?
what is polling?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?