I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
CTS,
7 21453Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
TCS,
3 9055i 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...?
TCS,
5 11982i have the source from Uk,north america how can i pass the data two tables based on the locations
2 5247I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
CSC,
4 14105hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
4 7483disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
2064col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
9 13649
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the types of containers?
What are the different plug-ins stages used in your projects?
What are the primary usages of datastage tool?
Differentiate between datastage and informatica?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Can you explain engine tier in information server?
On which interface you will be working as a developer?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are the difference types of stages?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Differentiate between odbc and drs stage?
How do y read Sequential file from job control?
How do you reject records in a transformer?
table actions available in oracle connector?