What is staging area?
Answers were Sorted based on User's Feedback
Answer / rukmini reddy
it is a temporary storage area.we can do data
clensing,scrubbing,merging.
| Is This Answer Correct ? | 1 Yes | 1 No |
What are two types of processes that informatica runs the session?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
what is a transforamation?
In joiner, how to load Master table in Target?
Define joiner transformation?
How to load only the first and last record of a flat file into the target?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
How can you run a session without using server manager?
What is active and passive transformation?
How can you differentiate between powercenter and power map?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do