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

I have source data like this
col1 col2 col3
5 3 8
6 2 9
7 1 10
and i want to get target as
col1 col2 col3
5 1 8
6 2 9
7 3 10
which transformation i have to use and how?

Question Posted / rajani.pichka

Answers were Sorted based on User's Feedback



I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want ..

Answer / siva

Take col1 and col3 in pipeline with a sequece generator,
and sorted values of col 2 in another pipeline with
sequence generator. Join both pipelines by sequence values
and send it to target.

for more details.. look into 5th page, last question, last
answer

Is This Answer Correct ?    1 Yes 1 No

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want ..

Answer / gd

sq-->Sorter t/r--->target

In sorter check the sorted port for col2 with ASC.

Is This Answer Correct ?    0 Yes 2 No

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want ..

Answer / rahul

use sorter trans

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

Quickly characterize reusable change?

0 Answers  

how we can update a target table without update strategy and update override?

3 Answers   TCS,

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,

What is a sorter transformation?

0 Answers   Informatica,

what is DSS?

3 Answers  

How is union transformation utilized?

0 Answers  

What are the prerequisite tasks to achieve the session partition?

0 Answers  

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

What are the types of groups in Router transformation?

1 Answers   Informatica,

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

Differentiate between Load Manager and DTM?

0 Answers  

For more Informatica Interview Questions Click Here
Categories