Interested to Buy Any Domain ? << Click Here >> for more details...
i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table.
can any tell me procedure.
- 2 Answers
- 7814 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jay
SCR-->SQ-->AGGR-----
| |
| v TRG 1
--------->RTR--> /
/ \
SEQ TRG 2
First get the count of records using Aggr t/r
and use this result in router t/r and have
router condition as SEQ < (Count / 2) for TRG 1
and default for TRG 2
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / mari ilavarasi
Using router transformation we can send half of the records
in one target and rest of the records will be inserted into
another target based on conditions.
| Is This Answer Correct ? | 6 Yes | 3 No |
task is running successfully but data is not loded why?
can we use self join in informaitca?
What are the different lookup cache(s)?
Why use shortcuts(Instead of making copies).
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to update source definition?
Explain load alternative records / rows into multiple targets - informatica
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
What is incremental aggregation?
Do you have to change the reject file b4 using reject loader utility.
Teradata 
