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

Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3

Question Posted / priya86.dwh

Answers were Sorted based on User's Feedback



Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3 ..

Answer / anu

take sequence annd router t/r 's
connct nextval port to router

create one group mod(nextval , 2)=0-------target1
default group-----------------------------target2

this is applicable to above six source rows only

this is my second logic
tell me any corrections

Is This Answer Correct ?    7 Yes 3 No

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3 ..

Answer / anu

Select distinct in sorter t/r
then run session twice
but don't enable truncate option in session target properties

I think so
any corrections tell me

Is This Answer Correct ?    2 Yes 1 No

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3 ..

Answer / arjun

hi,
take aggrtr in that take one var , count the var group by i/p these go to one tgt and take another same tgt for that, take aggrtr ports i.e, i/p and var ports to filter in that give cndtion not isnull(var) and take i/p port to secnd tgt.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

What is the Difference between DSS & OLTP?

5 Answers  

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

Which kind of index is preferred in DWH?

3 Answers  

What does reusable transformation mean?

0 Answers  

How many numbers of sessions can one group in batches?

0 Answers  

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

For more Informatica Interview Questions Click Here
Categories