Answer / pooja

In hash partitioning, the Informatica Server uses a hash function to group rows of data among partitions. The Informatica Server groups the data based on a partition key. Use hash partitioning when you want the Informatica Server to distribute rows to the partitions by group

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---

what is surrogate id ?

3 Answers   IBM,

---

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

2 Answers   ASM, TCS,

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers  

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

---

Explain about HLD and LLD ?

16 Answers   Accenture,

---

differences between service based and product based?

0 Answers   Satyam,

---

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

---