Hi ,
Please help how to achieve the following scenario.
I have a source table like this.
Rollno name class university
1 Raj 1st Sku
2 Ram 2nd SVU
3 Sam 3rd OU
I need the data in the target table like below.
Rollno name class university
1 Raj 1st Sku
2 Ram 2nd SVU
3 Sam 3rd OU
4 Rajesh 5th SKU
The Last row values we have.. and we have to append this
last row in the target table.
Thanks and Regards
Nataraj V
Answer Posted / rakesh
To append the data, Union Transformation is required. Both sources have same layout, they are input to Union Transformation and the desired output can be obtained.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How can we update a record in the target table without using update strategy?
can we override a native sql query within informatica? Where do we do it?
Where is metadata stored?
What is the sequence generator transformation in informatica?
How to use pmcmd utility command?
What is confirmed fact in dataware housing?
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
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
what are the deliverables?in your project?
What are the new features of Power Center 5.0?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
design of staging area?
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.