what r the transformations that r not involved in mapplet?
- 8 Answers
- 29174 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / vidya
1.Cobol source definition
2.Joiner transformation
3.Normalizer transformation
4.Sequence generator transformation
5.Pre or Post session stored procedures
6.Target definitions
7.XML source definitions
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What are the new features of Power Center 5.0?
What does “tail –f” command do and what is its use as an Informatica admin.
State the differences between sql override and lookup override?
What are some examples of informatica etl programs?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
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
Write the unconnected lookup syntax and how to return more than one column.
Explain what are the different versions of informatica?
What are data-driven sessions?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is rank index in rank transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Implementation methodology
What is a grid in Informatica?
