Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / natrajdreams

Answers were Sorted based on User's Feedback



Hi , Please help how to achieve the following scenario. I have a source table like this. Ro..

Answer / 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

Hi , Please help how to achieve the following scenario. I have a source table like this. Ro..

Answer / harleen

The question needs to be corrected.I think there are 3 rows already in the target and only one row has to be inserted.
The same can be done by 2 ways

1)Update strategy (Update as Insert)

2)Dynamic lookup

Is This Answer Correct ?    1 Yes 2 No

Hi , Please help how to achieve the following scenario. I have a source table like this. Ro..

Answer / abhinaw prakash

You can implement the same using SCD 1.

Please let me know if you have any doubt.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

In how many ways we can create ports?

0 Answers  

What are the types of maping in Getting Started Wizard?

1 Answers  

what is mean by grouping of condition column in lookup transformation?

1 Answers  

How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

list out all the transformations which use cache?

0 Answers   Informatica,

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

in which situations do u go for sequence generator ?

2 Answers   TCS,

Diffrence between static and dynamic cache

2 Answers   HCL,

For more Informatica Interview Questions Click Here
Categories