how can u avoid duplicate rows in flat file?
- 4 Answers
- 9531 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sunil
In a sorter transformation select distinct option to avoid
duplicates in a flat file
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What you know about transaction control transformation?
how many types of dimensions are available in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain sql transformation in script mode examples in informatica
Explain the shared cache and re-cache?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Design a mapping to load a target table with the following values from the above source?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
which one is better performance wise joiner or look up
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to create or import flat file definition in to the warehouse designer?
Briefly define a session task?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
