how to get flatfile containg 10 records half records one
target another half another target
Answers were Sorted based on User's Feedback
Answer / mahipal reddy
first create a sequence to those 10 records n using filter
or router transformation filter first 5 columns n load into
target similarly remianing 5 records.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / gazulas
what if the number 10 changes??
use a sql transfermation and get the record count or use an agg get rec count and pass it into record_count. use seq gen and populate the numbers. then use a router and write condition seq no <= record_count/2 -- target1
default to target 2.
this will work even ur records changes to 100 or 25o or 40000..etc
Is This Answer Correct ? | 0 Yes | 0 No |
Can we use the mapping parameters or variables created in one mapping into another mapping?
What is the reusable transformation?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
What is best approach to load 100 different source files (Different structure) to differet target tables ?
Do you have to change the reject file b4 using reject loader utility.
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
Where are the source flat files kept before running the session?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
How do we implement materialized view?when to use materialized view?
What is DR strategy for Informatica project?
What is DTM process?
How do you migrate data from one environment to another?