Whatis the difference between View and Materialized View ?
Answers were Sorted based on User's Feedback
Answer / guest
In view we cannot do DML commands where as it is possible
in Materialized view.
Is This Answer Correct ? | 39 Yes | 121 No |
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
How mapping parameter and variable works
Do you have knowledge in ralph kimball methodology
What is a joiner transformation and why it is an active one?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How would you copy the content of one repository to another repository?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
what r the transformations that r not involved in mapplet?
What is aggregate cache in aggregator transforamtion?
Under which circumstances, informatica server creates reject files?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks