Interested to Buy Any Domain ? << Click Here >> for more details...
how to get flatfile containg 10 records half records one
target another half another target
- 2 Answers
- 5499 Views
- I also Faced
- E-Mail Answers
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 |
how to we create datamart?
What the difference is between a database, a data warehouse and a data mart?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
Differentiate between a repository server and a powerhouse?
Difference between session variables and workflow variables?
How do you implement configuration management in Informatica?
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
How can yoU create or import flat file definition in to the warehouse designer?
What could be the possible resons of locks by user?
What is IQD file?
How to differentiate between the active and passive transformations?
Teradata 
