Posts

SQL Server Database Details

Image
SQL Query Execution flow:- The phases involved in the logical processing of an SQL query are as follows: FROM clause ON clause OUTER clause WHERE clause GROUP BY clause HAVING clause SELECT clause DISTINCT clause ORDER BY clause TOP clause

IICS Interview Questions and Answers

Image
  Mindtree Question and Answer:-  1.      How many transformation we can use in Synchronization task? And can we add multiple object as a source? Answer :-  Rules and Guidelines for a Multiple-Object Database   Use the following rules and guidelines when configuring a multiple-object database: All objects must be available through the same source connection. All database tables in a multiple-object source must have valid relationships defined by key columns or user-defined join conditions. When you add multiple database tables as sources for a task, you can either create relationships or user-defined joins, but not both. The Data Synchronization Task wizard removes a user-defined join under the following conditions: You remove one of two remaining database tables from the list of sources for the task. You change the source connection from database to flat file or Salesforce. 2. Have you worked on JSON Input? Answer : - No   3.   How do you re...

Informatica PowerCenter Questions and Answers

Informatica Intelligent Cloud Service (IICS)

Image
Informatica Informatica is a software development company founded in 1993. it is headquartered in Redwood City, California. Its core products include Enterprise Cloud Data Management and Data Integration.

Know about Language for Web Development

Image
Language Knowledge Sharing What are Front-End Languages? Front-end is the section of the web that users interact with. This includes everything that users can experience, see, and touch. Over the past years, the role of a web developer has changed, but its core functions are still the same. Frontend deals with a graphical user interface with various icons such as images, videos, and navigation menus. There is two type of development :- a) Web Development b) App Development  :-(Here need to choose operating system to develop on it like as Android O.S. OR IOS O.S.). Front-end v/s Back-end Development Frontend and backend are the most commonly used terms in the software development industry. Firstly, if we talk about frontend, it is basically the skin of the software. It is the ‘client-side’ of an application that can be seen, touched, and experienced. Everything that the user is viewing is a front end, such as application templates, buttons, navigation menus, etc. JavaScript, CSS, Re...

Computer Tips and Trick

 Convert PDF to Word:- first you should have one pdf file. you must have Microsoft Word 2019. open Microsoft word then select blank page then go to file menu-> open PDF File -> click yes from popup window. your file is converted into word file from PDF.  save it.

C Programming Practical Leaning

Image
C Progamming Language : - C is a powerful programming language that is used to develop operating systems, databases and more. Note:- int datatype keep positive and negative value and its size is 4 byte a per c programming language. Example :- WAP to take input from user and print it? #include<stdio.h> //it's used to write(scanf()) and read(prtinf())  //#include<math.h> //this library is used to perform math operation such as squre rool and square //#include<string.h> //This library is used to perform string function such as string copy, move etc. /* Note :- Here stdio means Standard Input output*/ void main() {   int a,b;   printf("enter value of a & b=> \n");   scanf("%d\n%d",&a,&b);   printf("a=> %d\nb=> %d",a,b); }   /*Output:-  enter value of a & b=>  -965 +5.6 a=> -965 b=> 5 */