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
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How many input parameters can exist in an unconnected lookup?
what is the size of u r source(like file or table)?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
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?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is aggregator transformation in informatica?
Write the prerequisite tasks to achieve the session partition?
What are active and passive transformations?
How can we update a record in the target table without using update strategy?
State the limitations where we cannot use joiner in the mapping pipeline?
how we can load rejected record's at run time?(not through bad files)
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
Design time, run time. If you don't create parameter what will happen
How many ways a relational source definition can be updated and what are they?