Interested to Buy Any Domain ? << Click Here >> for more details...
which T/r we can use it mapping parmeter and mapping
variable? and which one is reusable for any mapping mapping
parmeter or mapping varibale?
- 3 Answers
- 9102 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
i believe it is seq gen, filter, expression in which v can
use mapping parameter and variable.
mapping parameter is reusable. v simply change the value of
the parameter in the parameter fle.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
On which transformations you created partitions in your project?
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.
How can you generate reports in informatica?
what is degenerated dimension?
What is the use of code page?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain the types of transformations?
What is an Integration service 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
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to handle decimal places while importing a flatfile into informatica?
What is rank index in rank transformation?
