As explained above informatcia server has 3 methods to recovering the sessions.Use performing recovery to load the records from where the session fails.

ggk.krishna

 Profile Answers by ggk.krishna Questions by ggk.krishna

• Apr 8th, 2007

Hi,We can restart the session using session recovery option in workflow manager and workflow monitor. Then the loading starts from 10001 th row.If you start the session normally, it starts from 1 st row.If you define target load type as "Bulk", session recovery is not possible.

Answer Question  Select Best Answer

vinod madala

• May 11th, 2007

Pulling the data from same type of sources using a same database link is called Homogenous. The key word is same databse link (thats the system DSN we use).

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 22nd, 2007

Mr.,Go to source analyzerselect sources tab.select import from databases.it opens a child window which asks for username,password and connection name.there will be a button with '...' you pres...

Answer Question  Select Best Answer

vinodh259

 Profile Answers by vinodh259 Questions by vinodh259

• May 11th, 2007

provide optimizer hints to the informatica. such as force informatica to use indexes, synonyms, etc ..best technique is find ehich trnsformation is makin the mapping slow and  with that logic bui...

Answer Question  Select Best Answer

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 30th, 2007

Hi,You can do it through file list. You have create a file containing path of all file. And u have to give that file name in session properties and select indirect.Thanks,imran

Answer Question  Select Best Answer

How to assign a session/workflow to a particular SERVER? ( I have many servers, I want to assign one workflow to one server)

anupama2000

 Profile Answers by anupama2000 Questions by anupama2000

• May 26th, 2008

Go to assign server in the work flow manager and assign the particular server of your requirements.

Answer Question  Select Best Answer

g.nagaprasad

 Profile Answers by g.nagaprasad Questions by g.nagaprasad

• May 22nd, 2007

In lookup transformation there is a default clause ORDER BY...  but in case of Source Qualifier we have to give manually.

Answer Question  Select Best Answer

kasisarath

 Profile Answers by kasisarath Questions by kasisarath

• Jan 25th, 2008

There are several errors you will get. Couple of them are1.  if informatica failed to connect data base2. If source file not eixsts in location3. If paramerters not initilized with parameter file4. incompataible piped data types etc.

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• May 8th, 2007

We can create them manually or use the slowly changing dimension wizard to avoid the hassels.Use slowly changing dimension wizard and make necessary changes as per your logic.Hanu.

Answer Question  Select Best Answer

Abhishek Pathak

• May 25th, 2007

Main difference between using a object from shared folder is that it will be used as Shortcut to shared folder so in future if any changes happened to that object so by changing its definition in...

Answer Question  Select Best Answer

ajmani

 Profile Answers by ajmani Questions by ajmani

• Dec 6th, 2007

incase if only the target table name has changed ,then simply go to target designer, right click on target table name ->edit->rename it and say apply,u might not need to change in mapping design...

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• May 8th, 2007

U can use the scripting(either UNIX shell or Windows Dos scripting) and then schedule the script.Hanu.

Answer Question  Select Best Answer

yuva010

• Jun 20th, 2007

There is no as such best way, but you have to incorporate following steps -1. Change the name in Mapping Designer2. Refresh mapping?with right click on?session3. Reset the target connections.4. Save.

Answer Question  Select Best Answer

Hanu Ch Rao

• Feb 22nd, 2007

The first time you run a session with incremental aggregation enabled, the server process the entire source. At the end of the session, the server stores aggregate data from that session ran in two fi...

Answer Question  Select Best Answer

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 29th, 2007

Hi,The new Version Informatica 8.1 has got some additional feature's like:1) Mapping Generation Option2) Push Down Optimisation3) Data Cleanse and Match4) Data Federation (EII)5) Enterprise Grid6)...

Answer Question  Select Best Answer

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 29th, 2007

Hi Manish Bhai, Cofiguration management means when u r installing the informatica that time u have some options to set according to ur choice. Like u want to use unicode and ascii mode, there r some other options. I have only this much idea about it. If i am right then tell me.ThanksImran Nabi

Answer Question  Select Best Answer

Which transformation you can use to get n+1 records in Target database from N records source

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 29th, 2007

Normalizer bcoz it increases the no of rows. I hope it will help u.Thanks,imran

Answer Question  Select Best Answer

sivakumar

• May 2nd, 2007

It is not possible

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 26th, 2007

HiNt is using for cobol sources, u can take data in source analyzer automatically displays normalizer transformation. u can not use in mapplet.sreedhar

Answer Question  Select Best Answer

By using Update Strategy Transformation we use to maintain historical data using Type2 & Type3. By both of this which is better to use? Why?

sai

• Mar 26th, 2007

Using type 2  u can maintain total historical data along with current data;using type 3 u can maintain only one time historical data and currrent data:dased upon requrirement we have to choose the best suitable.

Answer Question  Select Best Answer