Interested to Buy Any Domain ? << Click Here >> for more details...
what is data driven?
- 5 Answers
- 53713 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
data driven is the instruction fed to informatica server
wheather to insert/update/delete row whenever using update
strategy transformation
| Is This Answer Correct ? | 59 Yes | 7 No |
Answer / ziauddin
When u configure a session using update strategy the
session property data driven instructs informatica server
to use the instructions coded in mapping to flag the rows
for insert, update, delete, this is the default option
selected when using a update strategy transformation in a
mapping.
| Is This Answer Correct ? | 32 Yes | 5 No |
Answer / kamesh
When ever a mapping contains Update Strategy Transformation
the way data needs to be treated is declared in the session
property as Data Driven. This is done by mentioning
DD_UPDATE or DD_INSERT or DD_DELETE in the update strategy
transformation.
A mapping may contain two Update strategy transformations,
1 for inserting and another for updating in two different
pipelines in single mapping.
Therefore, in order session to get executed successfully,
mention Data Driven property in the session properties for
that particular mapping.
| Is This Answer Correct ? | 23 Yes | 3 No |
Answer / yaseen
Data driven is a process, in which data is
insert/deleted/updated based on the data. here it is not
predifed tht data is to insert or delete or update .. it
will come to knw only when data is proceesed
| Is This Answer Correct ? | 10 Yes | 5 No |
Answer / maheshg
The informatica server follows instructions coded into
update Strategy transformations with in the session maping
determine how to flag records for insert,update,,delete or
reject If u do not choose data driven option setting,the
informatica server ignores all update strategy
transformations in the mapping
| Is This Answer Correct ? | 2 Yes | 0 No |
Write the different tools in the workflow manager?
What is joiner cache?
Enlist the advantages of informatica.
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
What is the difference between informatica 8.x and 9.x
How the informatica server increases the session performance through partitioning the source?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
Write the advantages of partitioning a session?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
To achieve the session partition what r the necessary tasks u have to do?
How will you update the first four rows and insert next four rows in a mapping?
Teradata 
