anbuselvan


{ City } chennai
< Country > india
* Profession * software engineer
User No # 122299
Total Questions Posted # 25
Total Answers Posted # 3

Total Answers Posted for My Questions # 4
Total Views for My Questions # 28962

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 0
Questions / { anbuselvan }
Questions Answers Category Views Company eMail

How many Key we can define in remove duplicate stage?

CTS,

Data Stage 811

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

CTS,

Data Stage 952

CHANGE CAPTURE

CTS,

Data Stage 877

AGGREGATOR default datatype

CTS,

Data Stage 922

Have you used Unstructured data?

CTS,

Data Stage 822

Triggers,VIEW,Procedures

CTS,

Data Stage 784

How to RD using transformer?

CTS,

Data Stage 850

How to Remove Duplicate using SQL?

CTS,

Data Stage 827

Lookup constraints

CTS,

Data Stage 831

Difference between JOIN,LOOKUP,MERGE?

CTS,

2 Data Stage 2187

EXPLAIN SCD

CTS,

Data Stage 948

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

CTS,

Data Stage 945

Terminate Activity

CTS,

Data Stage 833

Notification Activity

CTS,

Data Stage 888

How to reverse the string using unix?

CTS,

Data Stage 2787

 [1]   2    Next



Answers / { anbuselvan }

Question { TCS, 14250 }

Difference in the implementation of lookup and join
stages,in joining two tables?


Answer

one more point to add on MERGE and LOOKUP
Merge can not allow duplicate records whereas LOOKUP will allow or can control duplicates using OPTION"MULTIPLE ROWS ON THE LINK" which is in constraint TAB.

Is This Answer Correct ?    0 Yes 0 No

Question { 2129 }

Hi,
My source is oracle(eno,ename,sal,commision,...), my
requirement is like this,
if there is a null values in commission col i want to keep
it as null,and for the remaining first two characters of
the value in my target.

Plz help me


Answer

src--->TFM--->Tgt

in TFM for Commission column derivation,assign
If commission = NULL then NULL else LEFT(commision,1,2)

Hope this will work....correct me if i am wrong.

Is This Answer Correct ?    1 Yes 0 No


Question { 4754 }

what is the difference between the join and look up
explin me one exmple


Answer

1.Join needs key column metadata should be same|Lookup key column metadata its not mandatory to be same
2.Implement Four join in JOIN|But in Lookup only TWO JOIN(left outer,INNER)
3.JOIN does not have reject link | LOOKUP has one reject link
4.Data should be sorted and default is hash partioning |LOOKUP data need not to be in sort and default partioning is ENTIRE
5.Performance is HIGH in JOIN | Performance is less in JOIN
6.Duplicate will arise in JOIN|can handle Duplicate in LOOKUP

Is This Answer Correct ?    0 Yes 0 No