Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
TCS,
4 10625how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
HCL,
2186Two source files contains same meta data third file contains different data types can I funnel that file.
2 81613) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
2 61051)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.
4044i 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 21268source file contains 100 records, i want 10 records in target file how it possible in datastage
IBM,
6 24461one 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..........?
IBM,
8 13277diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
TCS,
1 4167
Can you implement SCD2 using join, transformer and funnel stage?
What is a merge in datastage?
What are the steps needed to create a simple basic datastage job?
What are the various kinds of the hash file?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the job parameters?
Define data aggregation?
What are the components of ascential data stage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are stage variables, derivations and constants?
What are stage variables?
What are the different plug-ins stages used in your projects?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Where the datastage stored his repository?
