Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
1)Source file contains one record, I want 100 records in target file.3 6371
Two source files contains same meta data third file contains different data types can I funnel that file.2 5717
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---20002 4011
I have 100 records how can I load at a time from the single time1 3762
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 102 4744
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 104 6060
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.3074
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?11 14255
source file contains 100 records, i want 10 records in target file how it possible in datastage
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are constraints and derivations?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How can we improve performance of data stage jobs?
How to find value from a column in a dataset?
What is the method of removing duplicates, without the remove duplicate stage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What all the types of jobs you developed?
What is the flow of loading data into fact & dimensional tables?
how do u catch bad rows from OCI stage? And what CLI stands for?
Where do the datastage jobs get stored?
What is the difference between account and directory options ?
Define meta stage?
What are some different alternative commands associated with "dsjob"?