Hope you learned from this video , below are link for other videos of IICS interview series , Please watcher 1:IICS Informatica Interview Questions : PART 1 YT video : ua-cam.com/video/UiVUGjWrsWI/v-deo.html 2:IICS Informatica Interview Questions : PART 2 YT video : ua-cam.com/video/MLlrV_Qjc78/v-deo.html
3:IICS Informatica Interview Questions : PART 3 YT video : ua-cam.com/video/zclMewJIwxc/v-deo.html 4:IICS Informatica Interview Questions : PART 4 YT video : ua-cam.com/video/9GNAdEzFJ1g/v-deo.html
Hi Friends Thank you for watching my video . Please subscribe to my channel like it and share it with your friends . also comment if you get any doubt on video , i will try to answer your doubt
The execution platform that run tasks. A runtime environment is either the Informatica Cloud Hosted Agent or a Secure Agent group. You must have at least one runtime environment in each organization so that users in the organization can run tasks.
it can be your system or informatica can also provide runtime to run jobs . anywhere it can be hosted , its basically where your secure agent is installed and running your taskflow by talking to source target etc
all the videos and interview part 1 , 2,3 are real interview questions. if you practice all videos and listen to all interview parts , 90% you will clear interview round of iics cloud integration . for oracle source per se , there is no specific limitations, i am not sure which limitation you are asking , please tell what it can not do .
@@ashishwankhede543 that is already available in rules for oracle in informatica documentation. here it is from document Rules and guidelines for Oracle sources and targets in tasks Use the following rules and guidelines for Oracle sources and targets in a task: • You can use database tables, synonyms, or views as sources and targets. • When you create a saved query to read data from an Oracle database, you must omit the final semicolon from the SQL statement. • You can't use the select * from SQL command in a saved query. You must provide the explicit column list. • If there is an error row when you run a task to write data to an Oracle target in bulk mode, the Secure Agent writes the batch that contains the error row in normal mode. • Ensure that the Oracle target table name does not contain mixed case identifiers. Rules and guidelines for Oracle sources and targets in tasks 13 • When you run a mapping task to create a target, the target is successfully created at runtime. If you drop the created target table and run the task again, the task fails. • When you add objects with a hyphen in the column names in the Source and Target transformations, consider the following rules and guidelines: - When the source column name that you read has hyphens and you use the Create New at Runtime option to create a target, the hyphens in the table name are converted to underscores in the target column. - If you add a new column to the object in an existing mapping and the column name has a hyphen, manually adding these columns in the mapping is not applicable. - If you parameterize the target object, the manual field map option in the Field Mapping tab is not applicable. You must select Automatic, Completely Parameterized, or Partially Parameterized as the field map options for the mapping to work successfully. • To write data in a sequence to an Oracle target in bulk mode, you can specify the following query syntax while creating an Oracle table: CREATE TABLE ( , ,... ) Ensure that the columns that you want to use in bulk mode must be of the integer data type. • You can't write data to an Oracle target when you configure a source partitioning and run the mapping in bulk mode. • When you read from Oracle, ensure that the Oracle table name or column name does not contain Unicode characters. Consider the following rules and guidelines when you use Oracle Autonomous Database sources and targets: • When you configure partitioning in bulk mode to write to Oracle Autonomous Database, use an existing target instead of creating a new target at run time. Otherwise, performance issue occurs. • To run a mapping that contains more than three source partitions, you must set the Service Name property value to low.
docs.informatica.com/integration-cloud/data-integration-connectors/current-version/oracle-connector/mappings-and-mapping-tasks-with-oracle-connector/oracle-sources-in-mappings.html at below you have guide , in that you will find this rules and guidelines
important thing is how much experience in iics , go through all interview questions in my channel and then search in other youtube channel as well . for 12 year experience they may ask some project which you develop end to end solution from source to target to reporting. they may also expect you to provide most difficult situations ( channeling scenario ) which you faced and how you solved it . performance tuning methods.
SUPPOSE ALL THES 75 VIDEOS PLAYLIST ON IICS IF WE MASTER. WHT WOULD BE THE LEVEL OF EXPERTISE IN TERMS OF NO OF YEARS OF EXPERIENCE AS PER YOUR OPINION.
Hope you learned from this video , below are link for other videos of IICS interview series ,
Please watcher
1:IICS Informatica Interview Questions : PART 1
YT video : ua-cam.com/video/UiVUGjWrsWI/v-deo.html
2:IICS Informatica Interview Questions : PART 2
YT video : ua-cam.com/video/MLlrV_Qjc78/v-deo.html
3:IICS Informatica Interview Questions : PART 3
YT video : ua-cam.com/video/zclMewJIwxc/v-deo.html
4:IICS Informatica Interview Questions : PART 4
YT video : ua-cam.com/video/9GNAdEzFJ1g/v-deo.html
Hi Friends Thank you for watching my video . Please subscribe to my channel like it and share it with your friends .
also comment if you get any doubt on video , i will try to answer your doubt
Hi Bro
Can you pls upload CDI & CAI ,
Cloud data integration & cloud application integration
Can I mail you Bro
You are doing good job to help various people with your videos. Really Appreciated.
thank you . keep watching
Dach Well
Really i found best channel❤❤
Good
@Roshan Please explain detail for run environment
The execution platform that run tasks. A runtime environment is either the Informatica Cloud Hosted Agent or a Secure Agent group. You must have at least one runtime environment in each organization so that users in the organization can run tasks.
it can be your system or informatica can also provide runtime to run jobs . anywhere it can be hosted , its basically where your secure agent is installed and running your taskflow by talking to source target etc
Good explanation.
thank you , plz watch myself other videos as well and provide feedback and ask if any doubt
❤❤❤❤❤❤❤❤
hi good job bro
thank you Vara , please watch all my videos in both playlist and provide feedback
Hi Roshan, please suggest some sources to learn CAI
ua-cam.com/play/PLonMTTEC0oeJWJsHqK_DicrzMU-7z3G3W.html&si=xw67qFA6KbQ-uckJ
ua-cam.com/play/PLonMTTEC0oeJWJsHqK_DicrzMU-7z3G3W.html&si=xw67qFA6KbQ-uckJ
Thanks a lot 🙏 waiting for your CAI tutorials...
What are the limitations of IIcs source as oracle database?
Please And the question faced into interview.
all the videos and interview part 1 , 2,3 are real interview questions. if you practice all videos and listen to all interview parts , 90% you will clear interview round of iics cloud integration .
for oracle source per se , there is no specific limitations, i am not sure which limitation you are asking , please tell what it can not do .
@@ETLSTATION every database has limitations so what is limitation for Oracle database
@@ashishwankhede543 that is already available in rules for oracle in informatica documentation. here it is from document
Rules and guidelines for Oracle sources and targets in tasks
Use the following rules and guidelines for Oracle sources and targets in a task:
• You can use database tables, synonyms, or views as sources and targets.
• When you create a saved query to read data from an Oracle database, you must omit the final semicolon from the SQL statement.
• You can't use the select * from SQL command in a saved query. You must provide the explicit column list.
• If there is an error row when you run a task to write data to an Oracle target in bulk mode, the Secure Agent writes the batch that contains the error row in normal mode.
• Ensure that the Oracle target table name does not contain mixed case identifiers.
Rules and guidelines for Oracle sources and targets in tasks 13
• When you run a mapping task to create a target, the target is successfully created at runtime. If you drop the created target table and run the task again, the task fails.
• When you add objects with a hyphen in the column names in the Source and Target transformations, consider the following rules and guidelines:
- When the source column name that you read has hyphens and you use the Create New at Runtime option to create a target, the hyphens in the table name are converted to underscores in the target column.
- If you add a new column to the object in an existing mapping and the column name has a hyphen, manually adding these columns in the mapping is not applicable.
- If you parameterize the target object, the manual field map option in the Field Mapping tab is not applicable. You must select Automatic, Completely Parameterized, or Partially Parameterized as the field map options for the mapping to work successfully.
• To write data in a sequence to an Oracle target in bulk mode, you can specify the following query syntax while creating an Oracle table:
CREATE TABLE ( , ,... )
Ensure that the columns that you want to use in bulk mode must be of the integer data type.
• You can't write data to an Oracle target when you configure a source partitioning and run the mapping in bulk mode.
• When you read from Oracle, ensure that the Oracle table name or column name does not contain Unicode characters.
Consider the following rules and guidelines when you use Oracle Autonomous Database sources and targets:
• When you configure partitioning in bulk mode to write to Oracle Autonomous Database, use an existing target instead of creating a new target at run time. Otherwise, performance issue occurs.
• To run a mapping that contains more than three source partitions, you must set the Service Name property value to low.
docs.informatica.com/integration-cloud/data-integration-connectors/current-version/oracle-connector/mappings-and-mapping-tasks-with-oracle-connector/oracle-sources-in-mappings.html
at below you have guide , in that you will find this rules and guidelines
@@ETLSTATION Thanks
Nice explaination but bit laaging
Hi there, thank you for feedback , these were inital videos , kindly watch my all other videos and see if its good .
Thank u soo much sir.. Its really helpful for me..
you are welcome , watch my all videos and other interview parts , i will upload a new part 5 this week
I have 3 yrs of experience in information now i want to change but im not getting calls any help ??
are you applying with powercneter and iics and unix and sql skillset ? nowadays market may be down , you need to keep applying .
Can you please let me know what questions will be asked for someone with 12+ years of experience
important thing is how much experience in iics , go through all interview questions in my channel and then search in other youtube channel as well . for 12 year experience they may ask some project which you develop end to end solution from source to target to reporting. they may also expect you to provide most difficult situations ( channeling scenario ) which you faced and how you solved it . performance tuning methods.
SUPPOSE ALL THES 75 VIDEOS PLAYLIST ON IICS IF WE MASTER. WHT WOULD BE THE LEVEL OF EXPERTISE IN TERMS OF NO OF YEARS OF EXPERIENCE AS PER YOUR OPINION.
3 years