what is data driven in informatica
Answers were Sorted based on User's Feedback
Answer / gyana
data driven is the session property.which tell the is to do
the operations on data as per the update strategy
transformation used in mapping..
it also defines that multiple database operations are done
in database(like insert,delete etc..
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / gyana
data driven is the session property.which tell the is to do
the operations on data as per the update strategy
transformation used in mapping..
it also defines that multiple database operations are done
in database(like insert,delete etc..
| Is This Answer Correct ? | 2 Yes | 0 No |
data driven is the session property.which tell the user to do
the operations on data as per the update strategy
transformation used in mapping..
As the the requirement we define the proprertie in session level for the
Update strategy transfermation like Inser,delete,update..
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / gyana
data driven is the session property.which tell the is to do
the operations on data as per the update strategy
transformation used in mapping..
it also defines that multiple database operations are done
in database(like insert,delete etc..
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gyana
data driven is the session property.which tell the is to do
the operations on data as per the update strategy
transformation used in mapping..
it also defines that multiple database operations are done
in database(like insert,delete etc..
| Is This Answer Correct ? | 0 Yes | 0 No |
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
What is confirmed dimension?
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
How will u find weather dimension table is big in size of a fact table?
What is meant by lookup transformation? Explain the types of lookup transformation?
Without using Lookup & Sequence Generator, How to generate Sequence?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
hw cn v elimate dublicate values from lookup without overriding sql?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks