Answer / soujanya

with out using any transformation we can directly load the
data to target this is known as SIMPLE PASS MAPPING. when
we drag the source to workspace the source automatically
generates source qualifier and from source we can connect
to target. In case of cobol files we use the normalizer
transformation. and remember source qualifier is also a
transformation rite.
soujanya mentay

Answer / shiva

simply connect source to target

but be very careful with the connections from source to
target

Answer / sree

at the time of draging source in to workspace it will auto
matically genartes sq t/r from this u connect to target

Answer / suren

yes it possible without using any transformation ,mappinf from sq to target .

Answer / gaurav rustogi

Simply connected souce with target.

If any condition is there we can put in the Source Qualifier

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

What is A cache?

2 Answers  

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

0 Answers  

What is the default source option for update stratgey transformation?

1 Answers  

what is workflow varible

1 Answers   HP,

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

0 Answers   CTS,

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,