Interested to Buy Any Domain ? << Click Here >> for more details...
suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?
- 9 Answers
- 13567 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shankar
SQ---->AGR---->RTR---->TGT
SEQ--->RTR
1) Pass all records to Agr
In AGR take count port ion taht give count(empno)
2)Next create SEQQUENCE GENERATOR connect nexval to router
3) Int RTR Create one Group called 1st half
In that give nextval<=count/2
4) Connect to TGTs from 2 groups (1st half and Default)
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is target load order?
What is the sequence generator transformation in informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
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
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How to create or import flat file definition in to the warehouse designer?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How to do unit testing in informatica? How to load data in informatica ?
What is the different lookup cache(s)?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is blocking transformation?
