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 10780how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
HCL,
2247Two source files contains same meta data third file contains different data types can I funnel that file.
2 82603) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
2 62181)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.
4098i 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 21579source file contains 100 records, i want 10 records in target file how it possible in datastage
IBM,
6 24708one 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 13491diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
TCS,
1 4242
What is difference between symmetric multiprocessing and massive parallel processing?
What is a folder? Difference types of stages?
Define ds designer?
how to add a new records into source?
Explain the importance of surrogate key in data warehousing?
What is process model?
Define meta stage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Does datastage support slowly changing dimensions ?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How many types of sorting methods are available in datastage?
How complex jobs are implemented in datstage to improve performance?
Is the value of staging variable stored temporarily or permanently?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
