Explain in detail scd type 2 through mapping.
No Answer is Posted For this Question
Be the First to Post Answer
How u use pdf file in informatica source?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are batches?
What is the difference between router and filter?
what is the purpose of surrogate key and diff between primary key&surrogate key
server hot-ws270 is connect to Repository B. What does it mean?
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
What are the tasks that Loadmanger process will do?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses