| Other Data Stage Interview Questions |
|| Asked @
|data stores in which location while using data set stage as the target?
|1.how to generate even numbers in surrogate or tranformar
2. how many ways to remove duplicate values?
|i have seq file that contents 10 million records load to target any data base..
in that case it takes lot of time for loading..how do performance tuning in that situation...?
|what is the difference between lookup stage reject link and
merge stage reject link in datastage Parallel jobs? interm
of output in Merge Reject link and Look Up Reject link ?
|if i have two tables
how can i get data as same as in tables?chandu
how can i implement scd typ1 and type2 in both server and in parallel?chandu
field1 field2 field3
suresh , 10,324 , 355 , 1234
ram , 23,456 , 450 , 456
balu ,40,346,23 , 275, 5678
how to remove the ,inthe fields?
|I am having the 2 source files A and B and I want to get the
output as, the data which is in file A and which doesn't in
file B to a target 1 and which is in file B and which doesn't
in file A to a target 2?
|what about data stage requirement
|How to remove ctrl M or(^M) characters in file using Sequential File stage?
|how do u capture duplicates through sort & transformer
|what is the difference between the join and look up
explin me one exmple
and Output should be like this
|plz tell me some dimentional and fact table names in banking
|For more Data Stage Interview Questions Click Here |