Welcome to the New York Area Informatica User Group. The goal of this group is to get together to learn, share, and collaborate with others that are working with or want to work with the Informatica products. The members of the group will help to decide on topics for future meetings, present their experiences, and learn from each other.
Hi All, I have recently appeared informatica certifcation 10 developer.Could any one provide me the correct answers for below Questions. What is the new datatype added in informatica 10 Decimal38 Given a Union transformation with 2 input groups, which statement is correct and true?(choose 2) A. Both input groups must have matching ports.…(Show moreShow less)
Referring to the SQL Transformation: which statements is correct and true.(choose 3) A. The SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline B. The SQL transformation in query mode can execute multiple SQL statements where components of the SQL…
Hi, My source is impala and i am using ODBC connection to fetch data. The source query has the concat() function. I am getting the below error if i run the workflow, but if i remove the function and give only one column its working fine. Message Code: RR_4035 Message: SQL Error [ FnName: Fetch Optimize -- [Cloudera][ODBC] (10510) Invalid…(Show moreShow less)
We want to run an ETL Job that stages and loads our Base Object's data, but stops before Match and Merge. Then we want to Match using a manual approach that only Matches Base Objects, and does not go on to Merge. When I look to one of my Base Objects to add a Job to my new Batch Group, I see 4 Match jobs: "Generate Match Tokens For Base…(Show moreShow less)