What are the new features of informatica 7.1?
Answers were Sorted based on User's Feedback
Answer / cuckoo sreedhar
Lookup on flat file is possible.
Union Transformation is present.
Version Control.
LDAP Authentication.
supporting of 64mb architecture.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sarath
1)We can use flat file as a target
2)we can use flat file as a lookup
3)Mainly union t/r is introuduced in 7.1
4)Data profiling and versioning
5)Propagate attributes
6)we can do partiotions upto 64
| Is This Answer Correct ? | 1 Yes | 0 No |
what is the flow?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
How to recover the standalone session?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
Explain lookup transformation source types in informatica
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
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.