Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 6915 Views
- IBM, I also Faced
- E-Mail Answers
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 |
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
performance tuning of Informatica
what are the differences between powercenter 8.1 and powercenter 8.5?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
How to extract original records at one target & Duplicate records at one target?
How to run a session, which contains mapplet?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
Types of error logs in Informatica?
what is Partitioning ? where we can use Partition?
Write the unconnected lookup syntax?
What is sql query override? When did u use sql query override?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
Teradata 
