explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS

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

3 Answers
12421 Views
IBM, Polaris, I also Faced
E-Mail Answers

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

Define oconv () and iconv () functions in datastage?

0 Answers

how can we join one oracle & flat files ?

2 Answers ME,

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?

0 Answers

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers Wipro,

AGGREGATOR default datatype

0 Answers CTS,

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers Cognizant, UHG,

what is the difference between the active datawarehouse and datawarehouse

1 Answers TCS,

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers Hexaware,

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers Patni,

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers IBM,

Name the third party tools that can be used in datastage?

0 Answers

Can aggregator and transformer stages use to sort the data? How ?

2 Answers

For more Data Stage Interview Questions Click Here