Informatica Developer Jobs Forum |
Get new comments by email
|
Current Discussions (70) - Start a Discussion
|
jdsony in Milton Keynes, United Kingdom |
flat fileHello folks can anyone walk me through the steps a developer needs to take once a flat file is delivered from a Mainframes System to the... |
|
SARAVANA KUMAR NARENDRAN in Madras, India Updated 7 months ago |
Informatica interview questions - 2 RepliesIf a flat file is given as source to a mapping and the target data has to be distinct rows, how do we achieve this in informatica mappings? |
|
swetha in West Des Moines, Iowa |
db connectionHi I am learning Informatica currently. Can anyone help me how can i know the target db connection,to run db on that particular db? Or anyone can... |
|
trivo in Hillsborough, New Jersey Updated 11 months ago |
Database error while running workflow - 5 RepliesHi Iam running a seesion.Iam unable to run Workflow.When i run Debug it shows me the data loaded into target. It shows me the following Error... |
|
Sneha in Mumbai, India |
Help with Informatica production support interview preparation.Hi All, I am into Informatica L1/L2 support. More towards the disaster & recovery planning side. I have a job interview coming up for Informatica... |
|
Sankar in Singapore, Singapore Updated 12 months ago |
Abinitio - Informatica - 2 RepliesHow easy is it to switch from Ab intio to Informatica in terms of learning and getting productive with the tool. I am very experienced in Ab... |
|
paola in New York, New York Updated 14 months ago |
Combining data of two similar flat files - 7 RepliesCan anybody tell me How to join two flat files so that the data from two of the comes to oracle target... all source and target have same... |
|
alex23 in Indianapolis, Indiana Updated 21 months ago |
informatica advice - 2 RepliesHi I would like to pursue a career in Informatica. How are the offers for informatica positions in US? Is the competition immense? Are the... |
|
Anil in Overland Park, Kansas Updated 25 months ago |
Which is faster in informatica? Flat file to database or database to database - 5 RepliesWhich load is faster in informatica? loading data from flat file to oracle schema. Or oracle table to another oracle table. |
|
Diksha Chopra in San Jose, California |
SAP BI and Informatica integrationHi all, I am assigned at the new project which deals with integrating SAP BI and Informatica so that we can extract data from informatica. I have... |
|
noelb1576 in Turlock, California |
Informatica/Data WarehousingI would like to know the purpose of creating a centralized data warehouse to store information from throughout the organization in order to improve... |
|
Vishnuvardhan in Madras, India |
Informatica Excel outputI want to get license for using excel file as an output. can anyone help me? |
|
babuswift in Madras, India Updated 31 months ago |
Informatica handling multiple result sets from Stored Procedure - 2 RepliesHello, This is regarding Informatica handling result sets returned from stored procedure. I am developing a cobol-db2 stored procedure which... |
|
Mallikarjun in New Delhi, India Updated 32 months ago |
Flat files - 1 ReplyThere are two different tables from two different SQL server database in my source and I need to populate the updated records in the target. My... |
|
AA in Alpharetta, Georgia Updated 33 months ago |
Insert update and delete on Target - 1 ReplyI have a source and target and I need to update insert and delete the target based on the source. For this I made a mapping with Dynamic lookup and... |
|
Kah Chong Lai in Singapore, Singapore |
Versioning in Informatica 8.6Currently we are using Informatica 8.6 in the production environment but we did not implement or enable versioning in Informatica. 1) If I will to... |
|
raja in Chennai, India Updated 33 months ago |
FTP connection type - ascii - 2 RepliesHi, The FTP connections in Informatica defaults to binarry mode transfer. Is there any way we can do an ascii mode transfer using informatica FTP... |
|
veerareddy in Mountain View, California |
How to handle columns from flatfile as a dataI am |
|
SQL Lion in Hyderabad, India Updated 37 months ago |
Lookup transformation - 3 RepliesHow to reject records which are not found in the lookup table? Currently it is inserting NULL values |
|
vasu in Bangalore, India |
Can we able to load the data in two different Environments in InformaticaHi Guys, I need one help from you.. Could you please tell me whether we can load the data into target table in this way. Let me explain my... |
|
kumar in Toronto, Ontario Updated 38 months ago |
Handling Rejected rows to Exception table(created through designer) - 4 RepliesHi, How can we handle or load the rejected rows to exception table. In the Task,i have filtered the rows in SQ & used Exp,next joiner,Exp &... |
|
swaminathan in Bombay, India |
ETL Developers with Informatica experienceFor a six months project in a Bank in Istanbul/Turkey, we are looking for developers with ETL, Informatica PowerCenter, Datawarehouse... |
|
Jeffrey Shoaf in King, North Carolina Updated 39 months ago |
Dynamically change the source and target - 2 Repliesthe scenario is: I have an input file to be uploaded in a database. I make the mappings and do it. Now if the fields in input file change i dont... |
|
Prasad in Independence, Ohio Updated 40 months ago |
How to load the data again in target which failed earlier - 1 ReplyRecords are loaded from table A to table B. while this jobs running some of records fail and go to table C. Now before this jobs run again, i have... |
|
nagesh_connect in Bombay, India Updated 41 months ago |
Informatica - 3 RepliesI am loading data from flat file to table,where I am seeing a special char as box in a column,so how can I skip that when reading from line. it... |
|
Majid Khan in Madras, India Updated 42 months ago |
Informatica 8: Connect to the server problem - 3 RepliesHi, I copied a repository from the production environment to the integration environment. All my workflows are valid on the integration... |
|
rajfrmchennai in Chennai, India |
Need help on setting up the target propertiesCould any one help me with an example how the data operations can be done such as insert, update as update, update as insert, insert else... |
|
naga in Framingham, Massachusetts Updated 45 months ago |
Using DB Sequence in Informatica mapping - 3 RepliesHow can I get Sequence number from a db sequence in informatica mapping? Regards, Chetty |
|
Rajeshkumar in Stamford, Connecticut Updated 46 months ago |
What is Mapplets?. Repository Objects that are not supported in Mapplets Why? - 1 ReplyWhat is Mapplets?. Repository Objects that are not supported in Mapplets Why? |
|
Rajeshkumar in Stamford, Connecticut Updated 46 months ago |
how to generate date for five years in informatica8 - 1 Replyi need a mappping which does not have a source but the date for five years is to be automatically generated.and dis has to be done in informatica... |
|
IntegrationHelp in Littleton, Colorado |
Informatica AnswersIf you can't resolve an issue try integrationhelp.blogspot.com |
|
Mahesh in Bangalore, India Updated 48 months ago |
Interview Preparation - 5 RepliesDo you have any tips to help prepare for an upcoming informatica developer interview? Are there common interview questions that come up again and... |
|
krishna pavan kumar boppana in Arlington Heights, Illinois |
Maintained views in Data Warehouse.Please can anybody knnow about the Views.and Which situation they use views like materilaized views |
|
Nandhini in Fords, New Jersey Updated 49 months ago |
transposed file extraction - 2 RepliesHi , I have a transposed file which reads like first name1 ph 1 address1 first name2 ph2 address2 firstname3 ph3 address3 e tc I... |
|
Nandhini in Fords, New Jersey Updated 49 months ago |
Creating a error log file - 2 RepliesHi, Im new in the Informatica environment. But my task is to create a error log file. I want the mapping to write to a error logfile not try to save... |
|
Moin in Cleveland, Ohio Updated 49 months ago |
Character $ to handle - 1 ReplyHi all, I have to concatenate 2 ports of string datatype, and one port value contains a '$' character. So my problem is that from the position of... |
|
Jay in Moline, Illinois Updated 51 months ago |
Can 2 versions of informatica , say Informatica 7 .x.x and informatica 8 be installed in the same server? - 1 ReplyCan 2 versions of informatica , say Informatica 7 .x.x and informatica 8 be installed in the same server? If yes, wat is the impact or consequence if... |
|
Bruce Mitchell in Sydney, Australia |
In Power center command task sort command not workingsort -k1.32,1.39 -k1.9,1.16 -k1.40,1.41 $PMTargetFileDir/PRODUCT_TARIFF_USG_INFO.DAT > $PMTargetFileDir/PRODUCT_TARIFF_USG_INFO_SORT.DAT I am... |
|
bssa in Ede, Netherlands |
SCD-2/TIMESTAMPno you can understand my problem it is SCD-TYPE2/TIMESTAMP PLz GIVE ME SOLUTIONS OK SOURCE mobile number(varchar2)... |
|
mishu in New Berlin, Wisconsin |
Driver ErrorHi... I was trying to load data from one table to the another table in the same database(Oracle)... though i could import the source and the target... |
|
Anubar in Cleveland, Ohio |
infpointHas anyone used 1stpOint's infpoint product for Informatica before? They are using it here and it seems to solve alot of issues in migrating code... |
|
sree in Minneapolis, Minnesota Updated 53 months ago |
8. when the mapping of the variable executed in informatica the variable is taken as……… - 1 Reply8. when the mapping of the variable executed in informatica the variable is taken as………options are integer data... |
|
kannan in Saint Paul, Minnesota Updated 53 months ago |
session speed - 1 Replycan any one tell me how to develop the session speed. |
|
bhaskar in London, United Kingdom Updated 53 months ago |
writing 2 target recs for each source rec - 1 ReplyI am new to Informatica and need to know how to write 2 records to my target for each source record. Some of the fields will be different for the 2... |
|
renu in Plainsboro, New Jersey |
interface technical consultantHI, Can anybody have an idea what Informatica/interface technical consultant means. I got one requiement with the job title Informatica/interface... |
|
priya in Hackensack, New Jersey Updated 54 months ago |
About Repository starting problem - 1 ReplyHi, Am working with informatica7.1.1 and sql server. while am starting the repository it throws an error msg(unable to stating the repository). can... |
|
priya in Hackensack, New Jersey Updated 54 months ago |
Need help on a mapping - 1 ReplyHi All, I am a Informatica learner. I was working on SQL Server DTS and SSIS ETL Tools before. I was thinking about a scenario: Say we... |
|
priya in Hackensack, New Jersey |
How can we make use of Packages in InformaticaCan anybody tell me how can we use Packages in informaatica? Thanks in advance Priya |
|
priya in Hackensack, New Jersey Updated 54 months ago |
Date Formatting in Informatica - 2 RepliesI am trying to do the following in the Expression Transformation but the results are surprising. GET_DATE_PART(Conversion_date,"MM") - This gives... |
|
Sergio in Buenos Aires, Argentina |
Reporting Errors/SuccessHello everybody! This is my first time here. I am having this problem with Informatica and I hope you can help me, thanks. I am supposed to... |
What's great about where you work? If you could change one thing about your job, what would it be? Got a question? Share the best and worst about what you do and where you work by joining a discussion or starting your own.
Subscribe to this forum as an RSS feed.
