Answer / amit trivedi

We need to use external tables to join a flat file and oracle table.
First insert all records of flat file into an external table and then join these two tables.

else, use next step, insert data from external table to oracle table and join these two tables using join conditions.

Answer / lokesh

first we need to converted flat files in tables ofter join
the oracle and that table

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

Lookup constraints

0 Answers   CTS,

---

How did you reconcile source with target?

2 Answers   HP,

---

Can you filter data in hashed file?

0 Answers  

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers  

---

specify data stage strength?

1 Answers  

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

What's the Main Function of the Staging area in DWH

3 Answers   Oracle,

---

what is the difference between == and eq in UNIX shell scripting?

0 Answers   CTS,

---

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

---

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

2 Answers   TIAA CREF,

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---