what is difference between migration project and integration
project? can anyone explain with the example
Thanks in advance
Answers were Sorted based on User's Feedback
Answer / d anil babu
integration project means two projects integrate to a single
project for one purpose
migration project means project already developed by one etl
tool.we take that project and develop that project with
another tool for same purpose
ex:informatica to datastage
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / d anil babu
hi this is anil.
migration project means already developed project developing
with another tool for same purpose
ex:informatica to datastage
integration:two or more projects intigrate to single project
for one purpose
Is This Answer Correct ? | 6 Yes | 2 No |
In merge stage can we update the values?
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
what is main difference between change capture and change apply stages
which unix commands mostly used in datastage
How can u write exception handling in seq file????
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(
How to read the length of word in unix?
Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?