Interested to Buy Any Domain ? << Click Here >> for more details...
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target?
I am new to Informatica,can anybody suggest me the idea?
- 2 Answers
- 4454 Views
- I also Faced
- E-Mail Answers
Answer Posted / sajid hussain
Step1: After SQ transformation take Sequence Generator transformation and edit properties like, Start Value=1, Increment By=1, End Value=3 and check the Cycle.
Step2: Now take a Router transformation and drag all the ports from SQ transformation to Router, as well as drag the NEXT VAL port from Sequence Generator transformation to Router.
Step3: Create 3 group T1, T2 and T3 and for each group condition will be like T1 --> NEXTVAL=1, T2 --> NEXTVAL=2 and T3 --> NEXTVAL=3
Step4: Connect all the 3 targets and run the mapping.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the differences between joiner transformation and source qualifier transformation?
What is the difference between informatics 7x and 8x and what is latest version?
What is data movement mode in Informatica and difference between them?
How many dimensions are there in informatica?
Mention some types of transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Slowly changing dimensions, types and where will you use them
What are the limitations of joiner transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What do mean by local and global repository?
What are the types of schemas we have in data warehouse.
What is DR strategy for Informatica project?
