explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
1695How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
CTS,
4 9087i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
TCS,
2 6559i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 15815Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
7 12504What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
1 8965Post New Informatica Questions
What is the use of transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Is stop and abort are same in informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Partition, what happens if the specified key range is shorter and longer
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
permutations of mapplet
Explain the different lookup methods used in informatica?
What is the surrogate key?
What is an expression transformation in informatica?
What are the different types of olap? Give an example?
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.
Clarify the aggregator change?
What does update strategy mean, and what are the different option of it?
