Interested to Buy Any Domain ? << Click Here >> for more details...
Hi please try to reply with answer. my mail id is
raghu.1028@gmail.com.
if the source is having millions of records, but having
theree target tables. As per user the first record need to
insert into first target and second record in to a second
target and third into third target, similarly the process
needs to repeat?
- 5 Answers
- 8246 Views
- I also Faced
- E-Mail Answers
Answer Posted / balaganesh
Using Sequence Generator and router we can achive this
problem.
In Seq Gen:
1) Set current value is 1 and end value is 3. Also, enable
the recycle option.
Now using router you can separate the records into target.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what is the main role of FI on business
what is pmrep command?
list and discuss two approaches for updation of target table in Informatica and how they are different.
if i have a query as flat file how can we load data to target table
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
When do we go for the tools in the market?
how do u set partition points in the mapping?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
what are the facilities provided by data warehouse to analytical users?
What are the etl testing operations includes?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Mention few test cases and explain them?
Explain do we need an etl tool?
what are the concerns of OLTP and DSS systems?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
