I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?
- 5 Answers
- 9913 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / koti
hi rucha could u tell me how the mod function can works and
how it will gives answer 1 or 2 or 3 only...
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
4 yrs etl devloper roles and responsibilities?any body give solutions
What is powercenter on grid?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Can we change Dynamic to Static or Persistent cache? If so what happens?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what is size of u r database?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Which version configuration tool used in ur project?
What are the popular informatica products?
What does reusable transformation mean?
How to generate sequence numbers?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
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
can we override a native sql query within informatica? Where do we do it? How do we do it?
