My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR

My Source qualifier has empno, sal.

Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET
SAL ------------>TARGET ?

Is this mapping valid or any issues are there if we design
like this?

Question Posted / manojdubba

3 Answers
6361 Views
Span Systems, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET ..

Answer / abhishek kumar

if second target is instance means name is different but
same target object than mapping is valid.

Is This Answer Correct ?

5 Yes

1 No

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET ..

Answer / srinivas

it is a valid mapping

Is This Answer Correct ?

1 Yes

0 No

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET ..

Answer / amedela chandra sekhar

mapping is valid but we should not do like this.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Informatica Interview Questions

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers Cap Gemini, IBM,

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?

0 Answers Bosch,

What are the circumstances that infromatica server results an unreciverable session?

1 Answers

What is the way to execute pl/sql script using informatica mapping?

0 Answers

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers PCS,

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers Wipro,

Why we use stored procedure transformation?

4 Answers

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers Patni,

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers

What is enterprise data warehousing?

0 Answers

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers

For more Informatica Interview Questions Click Here