Interested to Buy Any Domain ? << Click Here >> for more details...
Scenario:-
Below is the requirement.
Source:-
NAME ID Requirement
RAVI 1 (no need to repeat as it ID is 1)
KUMAR 3 (repeat 3 times as it ID is 3)
John 4 (repeat 4 times as it ID is 4)
Required Out Put:-
Name ID
RAVI 1
KUMAR 3
KUMAR 3
KUMAR 3
John 4
John 4
John 4
John 4
Scenario 2:-
Source Data
ID NAME
1,2 NETEZZA,ORACLE
3,4,5 SQL Server, DB2, Teradata
Required Output:-
ID NAME
1 NETEZZA
1 ORACLE
3 SQL Server
3 DB2
3 Teradata
- 1 Answers
- 4848 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer / krish
http://netezzamigration.blogspot.com/2014/10/implementing-java-transformation-with.html
| Is This Answer Correct ? | 2 Yes | 0 No |
How to send duplicates to one target and unique rows to one target?target is empty
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
What is version control in informatica ? Advance thanks
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
What is batch and describe about types of batches?
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
Difference between task flow and linear task flow
How to delete duplicate record in Informatica?
what type of problem you faced insales project or insurance project
Without using any transformations how u can load the data into target?
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 can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
Teradata 
