Interested to Buy Any Domain ? << Click Here >> for more details...
How can you recognise whether or not the newly added rows in
the source r gets insert in the target ?
- 2 Answers
- 8658 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
In the Type2 maping we have three options to recognise the
newly added rows
Version number
Flagvalue
Effective date Range
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / atiric software(raja)
by flag value we can identify the newly inserted rows
| Is This Answer Correct ? | 1 Yes | 0 No |
Name the different lookup cache(s)?
What are the types of schemas we have in data warehouse.
How can you define a transformation? What are different types of transformations in Informatica?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
What is parallel processing in informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
In informatica workflow manager, how many repositories can be created?
how to work with mapplet designer in informatica?
What is sequence generator transformation in informatica?
What is meant by LDAP users?
What is the difference between a repository server and a powerhouse?
what is diff b/t sorter t/r and agg have the option sorter property...
Teradata 
