Explain the importance of surrogate key in data warehousing?
No Answer is Posted For this Question
Be the First to Post Answer
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
what is the exact difference between dataset and fileset in datastage?
How you Remove the Dataset in Unix?
what is usage of datastage with materialized views
What is the difference between informatica and datastage?
How do you run datastage job from the command line?
Define project in datastage?
How do you generate sequence number in datastage?
Enlist various types of routines in datastage.
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..