Answer / venkateshmalneni

If the structure of the two flat files is same we can use SQ.by using in direct


if there is no common field in the two flat files then
create dummy columns in the exp t/r and then by using the dummy columns u can join them in the joiner t/r by giving the condition dummy = dummy1.
the flow is like this


src1--->SQ----->exp--->
|--->joiner---->target
src2--->SQ----->exp--->

Answer / gangam rajesh

using joiner transformation

Answer / mehul thakur

Hi Rajesh
could you plz tell me the steps to join from joiner tr.

Regards
Mehul Thakur

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  

---

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  

---

how to insert header after each group.

1 Answers   IBM,

---

How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  

---

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

What is operational data source (ODS)?

7 Answers  

---

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

How do you use reject loader.

0 Answers  

---

What is exclusive and normal mode for repository services?

0 Answers  

---