1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

explain how to create SCD-2 IN DATASTAGE 7.5X2
PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE
AND JOB DESINGN URGENT

Question Posted / vijay

Answers were Sorted based on User's Feedback



explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND..

Answer / harikiran

we can implement scd-2 in ds 7.5.2 server jobs by using
hash file and transformer stage. here hash file can act as
a lookup table.

Is This Answer Correct ?    4 Yes 0 No

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND..

Answer / guest

http://etl-tools.info/en/datastage-tutorial-L008_scd-implementation-datastage.htm

Is This Answer Correct ?    0 Yes 0 No

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND..

Answer / guest




Dim_table

change capture xfm

Src_table

Is This Answer Correct ?    0 Yes 6 No

Post New Answer

More Data Stage Interview Questions

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1 Answers  

If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,

how many write modes are there in ds

2 Answers   IBM,

Explain entity, attribute and relationship in datastage?

1 Answers  

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

1 Answers  

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

9 Answers   Cognizant, IBM, TCS, Virtusa,

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

explain about citrix scheduling tool in datastage

1 Answers   HSBC,

For more Data Stage Interview Questions Click Here
Categories