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?
No Answer is Posted For this Question
Be the First to Post Answer
Can you explain engine tier in information server?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
How did you reconcile source with target?
in aggregator , how can i get the sum in readable format
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
Is possible to create skid in dim,fact tables?
I have 100 records how can I load at a time from the single time
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
sed,awk,head