Informatica FAQ

load manager

hi..
"load manager' is the primary process of informatica power center server
"DTM-data transformation manager" is the secondary prcess..

go through the architecture  of informatica power center server..

thank u...
suvashis

Create a Dummy Port in both tables and assign same value e.g. 1 to both ports in expression transformation before joiner.
Now in join condition use this dummy port to join both tables.

You join these table using null key.

Pass {} to the key,I am sure it will work.

Regards,
Anshuman

Script can be used for several task
1) To run the worklfow, u can create script
2) To schedule the task/wkf u can schedule the script in cron tab
3) To Export/Import object
4) To automate the dep group
5) To bounce the service
U name it, and it can be done using script !!!1

Hi,

We can invoke Unix Scripts through

--> Command task
--> Under Session, Pre/Post session commands

ODBC.ini file has the entry of drivers required for the third party software like sybase, Teradata etc. Its located at server/bin loc.

Odbc.ini file is used to define the connections(DSN names,tcp/ip port) for database through which Informatica connects to the database.

First for Flat file a connection is not required.
All we need to provide is the path of the path in the mapping properties.

It will save in Informatica Server below path:

c:Informatica9.0.1serverinfa_sharedSrcFiles

U can use
ps -ef | grep USERID
where USERID is the Id with which the process is running.
It will give you output with two Id and detail of process name
kill PID
or
Kill -9 PID (if kill does not work )

If its an Unix installation, we can use the below commands:

ps_ef --> To know the processes running in backend.
kill -9 --> to kill a process forcefully.

If the ETL is not ussing Full Pushdown optimization or Target Pushdown optimization . We can track with insert Time_stamp

We can track the changes in SCD type 2 in many ways:

--> A time column
--> Mentioning a version

Create the EMAIL Task, in Properties Tab 1. EMAIL USER NAME : give the email id required 2. Subject as %w -- %e 3. Email Text as %g Session Start time : %b Session completion Time : %c Total Re...

Pls Help me,

how to send email from informaticas Log file is the Requirement, i need log file as Email IN Box

Hi,

We can use a sql in the sql override:

select count(1) from
(select * from where rownum<= (select count(1)-3 from )
minus
select * from where rownum<=3)

This query will remove the first 3 and the bottom 3 records.

Thanks

As i have mentioned previously first sort the table using sorter transformation and then use rank transformation. next by using expression transformation you can delee all rows as asked in question.

Sorry, if i am wrong. Please correct me.

Regards,
Karthik

Hi,

This can be achieved using an Aggregator transformation.

In the aggregator transformation, check the group by columns for all the source columns and add one extra output port in the aggregator.

OUT_TTL_RECORDS=count(*)

Pass this port value as the last record of the flat file target.

Thanks.

yes we hav to take lookup of target table. then follow the scd

Hi, Its similar to the SQL query, SELECT * FROM ,,.... FROM TABLE_NAME GROUP BY ,,..... HAVING COUNT(*)=1 Similarly in Informatica Aggregator transformation, select group by for all the columns and...

With respect to your query. Try getting the session log details regarding the session run. In case if you are not able to get sufficient informations, running the workflow in Verbose data mode. That will give you an exact account where things went wrong.

Cheers
Arun

Hi, I think we can obtain the results by using Joiner transformation. If the sources have no common columns, we can add one extra column with a value 1 in both the sources and then can join based on ...

There is a concept of Indirect filelist for processing multiple files with similar structure.

What if there are n source files(number may vary) with the same structure? File name maybe similar for e.g. TxtFile_1,TxtFile_2,TxtFile_3...........TxtFile_n

When an Aggregator transformation is used without sorter, it stores all the data before performing the grouping operation. But when a sorter is used before aggregator, it sorts all the data before pas...

passing data to sorter is time taking why because sorter transf stores whole data in buffer and then sorts based in specified ports.insted of passing data to sorter transf ,sort d data in the sours...

Sorry for my previous post. I missed a bit of question.

select * from where version in (select max(version) from group by id, loc_no)

select * from where version=(select max(version) from )

Hi, One way of getting only the duplicate columns loaded in the target table is to modify the SQ query: When primary keys are defined: select * from where exists (select PK1,PK2,... from group b...

i think you can write the sql query (delete from....) in session post-sql command and it will work good.

If we drop any sessions accidentally, it wont be deleted permanently until we do a check in. So if we want to recover the session, we can do a undo checkout on the session.

If you dropped your session or folder we can get it back if it has proper backup.we can also get it back when you have same folders in other environment, I mean to say, generally, we will have th...

It can be done using a setvariable function. We need to add a mapping variable with the initial value given as 0.

Then in the expression transformation:
1. Seq_No -->
2. Out_Seq_No --> setvariable(,)

At every run, the value of the mapping variable will be incremented by 1.

Thanks.

By using pre SQL in source qualifier we can generate sequence in the target

OR
It can be implemented throuh Lookup Transformation, Develope the lookup transformation with condition like NEXTVAL=CURVAL+1, Through this conditon we can acheive.

Hi,

We can capture the delta changes by using a look up transformation followed by an update strategy transformation with which can insert,delete and update records.

Thanks.