What is difference between Informatica 6.2 Workflow and
Informatica Workflow 7.1
Answer Posted / surya
new features in informatica 7.1 was
1. union transformation is added
2. custom ,, ,,
3. we can take flat file as lookup table
4.pmcmd command
5. server grid
6. transaction controle transformation
7. file repository concept
8.test load
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is informatica?
without table how to come first record only in oracle?
How can we use batches?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Briefly explain the aggregator transformation?
How do you use reject loader.
How does the aggregator transformation handle null values?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are active transformations.
State the limitations where we cannot use joiner in the mapping pipeline?
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.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?