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
- 13371 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 the fact table?
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
What are pre and post-session shell commands?
What is a filter transformation and why it is an active one?
Design a mapping to load a target table with the following values from the above source?
Which transformation is needed while using the Cobol sources as source definitions?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the advantages of using informatica as an etl tool over teradata?
How to configure mapping in informatica?
What are session parameters ? How do you set them?
What are the types of presistent cache in look up tr.
How an expression transformation differs from aggregator transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the different lookup cache(s)?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
