we hava a flat file having more than 1000 records and two
targets. i have to write first half of the rows into first
targets and next half of rows into second target. how can i
do in informetica??
Answer Posted / naveen
simple, use the router transformation. when u r able to
find which is the first half and which is the second half
exactly
But how to find ?
thats the second question , the clue is we can use sorter ,
aggregator , router itself to do this job.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
what is a worklet?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
What is fact? What are the types of facts?
What is the difference between project backlog and product backlog?
Explain about hash partitioning?
flat filevalidation in informatica
Explain the key challenges that you face while performing etl testing.
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
how do u really know that paging to disk is happening while u are using a lookup transform?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Explain do we need an etl tool?
Difference between flat files and relational sources?
Is hadoop a etl tool?