can we use lookup t/r in flat files?what are the t/r's can be
used in flat files when compared to relational DB?
Answers were Sorted based on User's Feedback
Answer / mike
1)Yes..you can use a lookup transformation on flatfiles.
2)I think we can use most of the transformations on
flatfiles.
But we can not apply slowly changing dimensions on flat
files.
correct me if i was wrong
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / rajan raorane
No we can apply slowly changin dimensions on flat files
as they are basically used to mantian history
frequently used is SDC2 (Verison/flag/Date)
Is This Answer Correct ? | 0 Yes | 2 No |
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
how do u use sequence created in oracle in informatica? Explain with an simple example
what is data modelling? what are types of modelling?In which suituation will use each one?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
how can u avoid duplicate rows in flat file?
How big was your fact table
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
What are the active and passive transforamtions?
Roles and Responsibilties of Informatica Production Support Member?
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?
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.