Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve
Answer Posted / sanjay
If you want to load these records on different files at
different time, you can use Filter transformation else u can
use Router transformation..
In Router trans create two ports and one default port.. and
write conditions according to your requirement....
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Enlist the tasks for which source qualifier transformation is used.
Why do you use Mapping Parameter and mapping variable?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Why union transformation is an active transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
State the limitations where we cannot use joiner in the mapping pipeline?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is the benefit of partitioning a session?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to start a workflow using pmcmd command?
Difference between Data and Index Caches?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Is it possible to define a single node as a Gateway node as well as worker node?