How to differentiate between the active and passive transformations?

1166

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 .

1946

What are batches?

1100

Define joiner transformation?

1049

What do you understand by SOA of Informatica?

989

what is unit testing?tell me proceedure

2222

In informatics server which files are created during the session rums?

1115

What is the use of code page?

1094

What is enterprise data warehousing?

1048

Scheduling properties,whats the default (sequential)

1955

What is rank transformation in informatica

1179

What is a repository? And how to add it in an informatica client?

1149

Explain scd type 3 through mapping.

1006

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1203

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2860