Interview Questions Answers in Data Stage

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 # 41851

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 1315

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

CTS,

Data Stage 1371

CHANGE CAPTURE

CTS,

Data Stage 1258

AGGREGATOR default datatype

CTS,

Data Stage 1389

Have you used Unstructured data?

CTS,

Data Stage 1269

Triggers,VIEW,Procedures

CTS,

Data Stage 1177

How to RD using transformer?

CTS,

Data Stage 1367

How to Remove Duplicate using SQL?

CTS,

Data Stage 1294

Lookup constraints

CTS,

Data Stage 1202

Difference between JOIN,LOOKUP,MERGE?

CTS,

2 Data Stage 3045

EXPLAIN SCD

CTS,

Data Stage 1341

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 1333

Terminate Activity

CTS,

Data Stage 1234

Notification Activity

CTS,

Data Stage 1350

How to reverse the string using unix?

CTS,

Data Stage 3432

[1] 2 Next

Answers / { anbuselvan }

Question { TCS, 16356 }

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 { 2828 }

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 { 5784 }

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